package jp.bsws.dao;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class RaitenJohoDao {
    private static RaitenJohoDao RaitenJohoDao = new RaitenJohoDao();

    /** ログです。 */
	private static Log log = LogFactory.getLog(RaitenJohoDao.class);

	/**
	 * コンストラクタです。
	 */
    // Singletonパターンで単一のインスタンスを取得
    public static RaitenJohoDao getInstance(){
    	return RaitenJohoDao;
    }






//    /**
//     * 売上詳細情報の登録
//     */
//	private String SQL_URIAGE_SYOSAI_INSERT =
//		" INSERT INTO " +
//		"     T_URIAGE_SYOSAI ( " +
//		"         GROUP_COD " +
//		"        ,TENPO_COD " +
//		"        ,URIAGE_YMD " +
//		"        ,JUGYOIN_COD " +
//		"        ,SHINKI_SU " +
//		"        ,SAIRAI_SU " +
//		"        ,SHIMEI_SU " +
//		"        ,NYUKYAKU_SU " +
//		"        ,HONTAI_KIN " +
//		"        ,SYOHIZEI_KIN " +
//		"        ,URIAGE_GOKEI_KIN " +
//		"        ,TANKA_KIN " +
//		"        ,HOSYU_GOKEI_KIN " +
//		"        ,RAITEN_YOIN1_COD " +
//		"        ,RAITEN_YOIN1_SU " +
//		"        ,RAITEN_YOIN2_COD " +
//		"        ,RAITEN_YOIN2_SU " +
//		"        ,RAITEN_YOIN3_COD " +
//		"        ,RAITEN_YOIN3_SU " +
//		"        ,RAITEN_YOIN4_COD " +
//		"        ,RAITEN_YOIN4_SU " +
//		"        ,RAITEN_YOIN5_COD " +
//		"        ,RAITEN_YOIN5_SU " +
//		"        ,RAITEN_YOIN6_COD " +
//		"        ,RAITEN_YOIN6_SU " +
//		"        ,RAITEN_YOIN7_COD " +
//		"        ,RAITEN_YOIN7_SU " +
//		"        ,RAITEN_YOIN8_COD " +
//		"        ,RAITEN_YOIN8_SU " +
//		"        ,URIAGE_SHUBETSU1_COD " +
//		"        ,URIAGE_SHUBETSU1_KIN " +
//		"        ,URIAGE_SHUBETSU2_COD " +
//		"        ,URIAGE_SHUBETSU2_KIN " +
//		"        ,URIAGE_SHUBETSU3_COD " +
//		"        ,URIAGE_SHUBETSU3_KIN " +
//		"        ,URIAGE_SHUBETSU4_COD " +
//		"        ,URIAGE_SHUBETSU4_KIN " +
//		"        ,URIAGE_SHUBETSU5_COD " +
//		"        ,URIAGE_SHUBETSU5_KIN " +
//		"        ,URIAGE_SHUBETSU6_COD " +
//		"        ,URIAGE_SHUBETSU6_KIN " +
//		"        ,URIAGE_SHUBETSU7_COD " +
//		"        ,URIAGE_SHUBETSU7_KIN " +
//		"        ,URIAGE_SHUBETSU8_COD " +
//		"        ,URIAGE_SHUBETSU8_KIN " +
//		"        ,SHIHARAI_HOHO1_COD " +
//		"        ,SHIHARAI_HOHO1_KIN " +
//		"        ,SHIHARAI_HOHO2_COD " +
//		"        ,SHIHARAI_HOHO2_KIN " +
//		"        ,SHIHARAI_HOHO3_COD " +
//		"        ,SHIHARAI_HOHO3_KIN " +
//		"        ,SHIHARAI_HOHO4_COD " +
//		"        ,SHIHARAI_HOHO4_KIN " +
//		"        ,SHIHARAI_HOHO5_COD " +
//		"        ,SHIHARAI_HOHO5_KIN " +
//		"        ,HOSYU_SHUBETSU1_COD " +
//		"        ,HOSYU_SHUBETSU1_KIN " +
//		"        ,HOSYU_SHUBETSU2_COD " +
//		"        ,HOSYU_SHUBETSU2_KIN " +
//		"        ,HOSYU_SHUBETSU3_COD " +
//		"        ,HOSYU_SHUBETSU3_KIN " +
//		"        ,HOSYU_SHUBETSU4_COD " +
//		"        ,HOSYU_SHUBETSU4_KIN " +
//		"        ,HOSYU_SHUBETSU5_COD " +
//		"        ,HOSYU_SHUBETSU5_KIN " +
//		"        ,HOSYU_SHUBETSU6_COD " +
//		"        ,HOSYU_SHUBETSU6_KIN " +
//		"        ,HOSYU_SHUBETSU7_COD " +
//		"        ,HOSYU_SHUBETSU7_KIN " +
//		"        ,HOSYU_SHUBETSU8_COD " +
//		"        ,HOSYU_SHUBETSU8_KIN " +
//		"        ,KOSHIN_TMS " +
//		"        ,KOSHINSHA_COD " +
//		"     ) VALUES ( " +
//		"        ? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,? " +
//		"       ,now() " +
//		"       ,? " +
//		"    ) ";
//
//	/**
//	 * 売上詳細情報追加
//	 */
//	public int insertUriageSyosai(Connection con, BSWSSession bSWSSession , RaitenJohoBean raitenJohoBean, String strSansyoTenpoCod, String strSansyoYmd) throws Exception{
//
//		PreparedStatement stmt = con.prepareStatement(SQL_URIAGE_SYOSAI_INSERT);
//
//		stmt.setString(1, bSWSSession.getStrGroupCod());
//		stmt.setString(2, strSansyoTenpoCod);
//		stmt.setInt(3, Integer.parseInt(strSansyoYmd));
//		stmt.setString(4, raitenJohoBean.getStrTantoCod());
//		stmt.setInt(5, BSWSUtils.getZeroInteger(raitenJohoBean.getStrShinki()));
//		stmt.setInt(6, BSWSUtils.getZeroInteger(raitenJohoBean.getStrSairai()));
//		stmt.setInt(7, BSWSUtils.getZeroInteger(raitenJohoBean.getStrShimei()));
//		stmt.setInt(8, BSWSUtils.getZeroInteger(raitenJohoBean.getStrNyukyaku()));
//		stmt.setInt(9, BSWSUtils.getZeroInteger(raitenJohoBean.getStrHontaiKingaku()));
//		stmt.setInt(10, BSWSUtils.getZeroInteger(raitenJohoBean.getStrSyohizei()));
//		stmt.setInt(11, BSWSUtils.getZeroInteger(raitenJohoBean.getStrUriageGokei()));
//		stmt.setInt(12, BSWSUtils.getZeroInteger(raitenJohoBean.getStrTanka()));
//		stmt.setInt(13, BSWSUtils.getZeroInteger(raitenJohoBean.getStrHosyuGokei()));
//		List<KeyValueBean> tmpRaitenYoinList = BSWSUtils.getKeyValueBeanList(raitenJohoBean.getRaitenYoinList(), 8);
//		{
//			KeyValueBean kv1 = tmpRaitenYoinList.get(0);
//			stmt.setString(14, kv1.getKey());
//			stmt.setInt(15, BSWSUtils.getZeroInteger(kv1.getValue()));
//			KeyValueBean kv2 = tmpRaitenYoinList.get(1);
//			stmt.setString(16, kv2.getKey());
//			stmt.setInt(17, BSWSUtils.getZeroInteger(kv2.getValue()));
//			KeyValueBean kv3 = tmpRaitenYoinList.get(2);
//			stmt.setString(18, kv3.getKey());
//			stmt.setInt(19, BSWSUtils.getZeroInteger(kv3.getValue()));
//			KeyValueBean kv4 = tmpRaitenYoinList.get(3);
//			stmt.setString(20, kv4.getKey());
//			stmt.setInt(21, BSWSUtils.getZeroInteger(kv4.getValue()));
//			KeyValueBean kv5 = tmpRaitenYoinList.get(4);
//			stmt.setString(22, kv5.getKey());
//			stmt.setInt(23, BSWSUtils.getZeroInteger(kv5.getValue()));
//			KeyValueBean kv6 = tmpRaitenYoinList.get(5);
//			stmt.setString(24, kv6.getKey());
//			stmt.setInt(25, BSWSUtils.getZeroInteger(kv6.getValue()));
//			KeyValueBean kv7 = tmpRaitenYoinList.get(6);
//			stmt.setString(26, kv7.getKey());
//			stmt.setInt(27, BSWSUtils.getZeroInteger(kv7.getValue()));
//			KeyValueBean kv8 = tmpRaitenYoinList.get(7);
//			stmt.setString(28, kv8.getKey());
//			stmt.setInt(29, BSWSUtils.getZeroInteger(kv8.getValue()));
//		}
//		List<KeyValueBean> tmpUriageShubetsuList = BSWSUtils.getKeyValueBeanList(raitenJohoBean.getUriageShubetsuList(), 8);
//		{
//			KeyValueBean kv1 = tmpUriageShubetsuList.get(0);
//			stmt.setString(30, kv1.getKey());
//			stmt.setInt(31, BSWSUtils.getZeroInteger(kv1.getValue()));
//			KeyValueBean kv2 = tmpUriageShubetsuList.get(1);
//			stmt.setString(32, kv2.getKey());
//			stmt.setInt(33, BSWSUtils.getZeroInteger(kv2.getValue()));
//			KeyValueBean kv3 = tmpUriageShubetsuList.get(2);
//			stmt.setString(34, kv3.getKey());
//			stmt.setInt(35, BSWSUtils.getZeroInteger(kv3.getValue()));
//			KeyValueBean kv4 = tmpUriageShubetsuList.get(3);
//			stmt.setString(36, kv4.getKey());
//			stmt.setInt(37, BSWSUtils.getZeroInteger(kv4.getValue()));
//			KeyValueBean kv5 = tmpUriageShubetsuList.get(4);
//			stmt.setString(38, kv5.getKey());
//			stmt.setInt(39, BSWSUtils.getZeroInteger(kv5.getValue()));
//			KeyValueBean kv6 = tmpUriageShubetsuList.get(5);
//			stmt.setString(40, kv6.getKey());
//			stmt.setInt(41, BSWSUtils.getZeroInteger(kv6.getValue()));
//			KeyValueBean kv7 = tmpUriageShubetsuList.get(6);
//			stmt.setString(42, kv7.getKey());
//			stmt.setInt(43, BSWSUtils.getZeroInteger(kv7.getValue()));
//			KeyValueBean kv8 = tmpUriageShubetsuList.get(7);
//			stmt.setString(44, kv8.getKey());
//			stmt.setInt(45, BSWSUtils.getZeroInteger(kv8.getValue()));
//		}
//		List<KeyValueBean> tmpShiharaiHohoList = BSWSUtils.getKeyValueBeanList(raitenJohoBean.getShiharaiHohoList(), 5);
//		{
//			KeyValueBean kv1 = tmpShiharaiHohoList.get(0);
//			stmt.setString(46, kv1.getKey());
//			stmt.setInt(47, BSWSUtils.getZeroInteger(kv1.getValue()));
//			KeyValueBean kv2 = tmpShiharaiHohoList.get(1);
//			stmt.setString(48, kv2.getKey());
//			stmt.setInt(49, BSWSUtils.getZeroInteger(kv2.getValue()));
//			KeyValueBean kv3 = tmpShiharaiHohoList.get(2);
//			stmt.setString(50, kv3.getKey());
//			stmt.setInt(51, BSWSUtils.getZeroInteger(kv3.getValue()));
//			KeyValueBean kv4 = tmpShiharaiHohoList.get(3);
//			stmt.setString(52, kv4.getKey());
//			stmt.setInt(53, BSWSUtils.getZeroInteger(kv4.getValue()));
//			KeyValueBean kv5 = tmpShiharaiHohoList.get(4);
//			stmt.setString(54, kv5.getKey());
//			stmt.setInt(55, BSWSUtils.getZeroInteger(kv5.getValue()));
//		}
//		List<KeyValueBean> tmpHosyuShubetsuList = BSWSUtils.getKeyValueBeanList(raitenJohoBean.getHosyuShubetsuList(), 8);
//		{
//			KeyValueBean kv1 = tmpHosyuShubetsuList.get(0);
//			stmt.setString(56, kv1.getKey());
//			stmt.setInt(57, BSWSUtils.getZeroInteger(kv1.getValue()));
//			KeyValueBean kv2 = tmpHosyuShubetsuList.get(1);
//			stmt.setString(58, kv2.getKey());
//			stmt.setInt(59, BSWSUtils.getZeroInteger(kv2.getValue()));
//			KeyValueBean kv3 = tmpHosyuShubetsuList.get(2);
//			stmt.setString(60, kv3.getKey());
//			stmt.setInt(61, BSWSUtils.getZeroInteger(kv3.getValue()));
//			KeyValueBean kv4 = tmpHosyuShubetsuList.get(3);
//			stmt.setString(62, kv4.getKey());
//			stmt.setInt(63, BSWSUtils.getZeroInteger(kv4.getValue()));
//			KeyValueBean kv5 = tmpHosyuShubetsuList.get(4);
//			stmt.setString(64, kv5.getKey());
//			stmt.setInt(65, BSWSUtils.getZeroInteger(kv5.getValue()));
//			KeyValueBean kv6 = tmpHosyuShubetsuList.get(5);
//			stmt.setString(66, kv6.getKey());
//			stmt.setInt(67, BSWSUtils.getZeroInteger(kv6.getValue()));
//			KeyValueBean kv7 = tmpHosyuShubetsuList.get(6);
//			stmt.setString(68, kv7.getKey());
//			stmt.setInt(69, BSWSUtils.getZeroInteger(kv7.getValue()));
//			KeyValueBean kv8 = tmpHosyuShubetsuList.get(7);
//			stmt.setString(70, kv8.getKey());
//			stmt.setInt(71, BSWSUtils.getZeroInteger(kv8.getValue()));
//		}
//		stmt.setString(72, bSWSSession.getStrJugyoinCod());
//
//		int cnt = stmt.executeUpdate();
//
//		stmt.close();
//
//		return cnt;
//	}
//
//    /**
//     * 売上詳細情報の更新
//     */
//	private String SQL_URIAGE_SYOSAI_UPDATE =
//		" UPDATE " +
//		"     T_URIAGE_SYOSAI  " +
//		" SET " +
//		"         SHINKI_SU  = ? " +
//		"        ,SAIRAI_SU  = ? " +
//		"        ,SHIMEI_SU  = ? " +
//		"        ,NYUKYAKU_SU  = ? " +
//		"        ,HONTAI_KIN  = ? " +
//		"        ,SYOHIZEI_KIN  = ? " +
//		"        ,URIAGE_GOKEI_KIN  = ? " +
//		"        ,TANKA_KIN  = ? " +
//		"        ,HOSYU_GOKEI_KIN  = ? " +
//		"        ,RAITEN_YOIN1_COD  = ? " +
//		"        ,RAITEN_YOIN1_SU  = ? " +
//		"        ,RAITEN_YOIN2_COD  = ? " +
//		"        ,RAITEN_YOIN2_SU  = ? " +
//		"        ,RAITEN_YOIN3_COD  = ? " +
//		"        ,RAITEN_YOIN3_SU  = ? " +
//		"        ,RAITEN_YOIN4_COD  = ? " +
//		"        ,RAITEN_YOIN4_SU  = ? " +
//		"        ,RAITEN_YOIN5_COD  = ? " +
//		"        ,RAITEN_YOIN5_SU  = ? " +
//		"        ,RAITEN_YOIN6_COD  = ? " +
//		"        ,RAITEN_YOIN6_SU  = ? " +
//		"        ,RAITEN_YOIN7_COD  = ? " +
//		"        ,RAITEN_YOIN7_SU  = ? " +
//		"        ,RAITEN_YOIN8_COD  = ? " +
//		"        ,RAITEN_YOIN8_SU  = ? " +
//		"        ,URIAGE_SHUBETSU1_COD  = ? " +
//		"        ,URIAGE_SHUBETSU1_KIN  = ? " +
//		"        ,URIAGE_SHUBETSU2_COD  = ? " +
//		"        ,URIAGE_SHUBETSU2_KIN  = ? " +
//		"        ,URIAGE_SHUBETSU3_COD  = ? " +
//		"        ,URIAGE_SHUBETSU3_KIN  = ? " +
//		"        ,URIAGE_SHUBETSU4_COD  = ? " +
//		"        ,URIAGE_SHUBETSU4_KIN  = ? " +
//		"        ,URIAGE_SHUBETSU5_COD  = ? " +
//		"        ,URIAGE_SHUBETSU5_KIN  = ? " +
//		"        ,URIAGE_SHUBETSU6_COD  = ? " +
//		"        ,URIAGE_SHUBETSU6_KIN  = ? " +
//		"        ,URIAGE_SHUBETSU7_COD  = ? " +
//		"        ,URIAGE_SHUBETSU7_KIN  = ? " +
//		"        ,URIAGE_SHUBETSU8_COD  = ? " +
//		"        ,URIAGE_SHUBETSU8_KIN  = ? " +
//		"        ,SHIHARAI_HOHO1_COD  = ? " +
//		"        ,SHIHARAI_HOHO1_KIN  = ? " +
//		"        ,SHIHARAI_HOHO2_COD  = ? " +
//		"        ,SHIHARAI_HOHO2_KIN  = ? " +
//		"        ,SHIHARAI_HOHO3_COD  = ? " +
//		"        ,SHIHARAI_HOHO3_KIN  = ? " +
//		"        ,SHIHARAI_HOHO4_COD  = ? " +
//		"        ,SHIHARAI_HOHO4_KIN  = ? " +
//		"        ,SHIHARAI_HOHO5_COD  = ? " +
//		"        ,SHIHARAI_HOHO5_KIN  = ? " +
//		"        ,HOSYU_SHUBETSU1_COD  = ? " +
//		"        ,HOSYU_SHUBETSU1_KIN  = ? " +
//		"        ,HOSYU_SHUBETSU2_COD  = ? " +
//		"        ,HOSYU_SHUBETSU2_KIN  = ? " +
//		"        ,HOSYU_SHUBETSU3_COD  = ? " +
//		"        ,HOSYU_SHUBETSU3_KIN  = ? " +
//		"        ,HOSYU_SHUBETSU4_COD  = ? " +
//		"        ,HOSYU_SHUBETSU4_KIN  = ? " +
//		"        ,HOSYU_SHUBETSU5_COD  = ? " +
//		"        ,HOSYU_SHUBETSU5_KIN  = ? " +
//		"        ,HOSYU_SHUBETSU6_COD  = ? " +
//		"        ,HOSYU_SHUBETSU6_KIN  = ? " +
//		"        ,HOSYU_SHUBETSU7_COD  = ? " +
//		"        ,HOSYU_SHUBETSU7_KIN  = ? " +
//		"        ,HOSYU_SHUBETSU8_COD  = ? " +
//		"        ,HOSYU_SHUBETSU8_KIN  = ? " +
//		"        ,KOSHIN_TMS  = now() " +
//		"        ,KOSHINSHA_COD  = ? " +
//		" WHERE " +
//		"     GROUP_COD = ? " +
//		" AND TENPO_COD = ? " +
//		" AND URIAGE_YMD = ? "+
//		" AND JUGYOIN_COD = ? ";
//
//	/**
//	 * 売上詳細情報追加
//	 */
//	public int updateUriageSyosai(Connection con, BSWSSession bSWSSession , RaitenJohoBean raitenJohoBean, String strSansyoTenpoCod, String strSansyoYmd) throws Exception{
//
//		PreparedStatement stmt = con.prepareStatement(SQL_URIAGE_SYOSAI_UPDATE);
//
//		stmt.setInt(1, BSWSUtils.getZeroInteger(raitenJohoBean.getStrShinki()));
//		stmt.setInt(2, BSWSUtils.getZeroInteger(raitenJohoBean.getStrSairai()));
//		stmt.setInt(3, BSWSUtils.getZeroInteger(raitenJohoBean.getStrShimei()));
//		stmt.setInt(4, BSWSUtils.getZeroInteger(raitenJohoBean.getStrNyukyaku()));
//		stmt.setInt(5, BSWSUtils.getZeroInteger(raitenJohoBean.getStrHontaiKingaku()));
//		stmt.setInt(6, BSWSUtils.getZeroInteger(raitenJohoBean.getStrSyohizei()));
//		stmt.setInt(7, BSWSUtils.getZeroInteger(raitenJohoBean.getStrUriageGokei()));
//		stmt.setInt(8, BSWSUtils.getZeroInteger(raitenJohoBean.getStrTanka()));
//		stmt.setInt(9, BSWSUtils.getZeroInteger(raitenJohoBean.getStrHosyuGokei()));
//		List<KeyValueBean> tmpRaitenYoinList = BSWSUtils.getKeyValueBeanList(raitenJohoBean.getRaitenYoinList(), 8);
//		{
//			KeyValueBean kv1 = tmpRaitenYoinList.get(0);
//			stmt.setString(10, kv1.getKey());
//			stmt.setInt(11, BSWSUtils.getZeroInteger(kv1.getValue()));
//			KeyValueBean kv2 = tmpRaitenYoinList.get(1);
//			stmt.setString(12, kv2.getKey());
//			stmt.setInt(13, BSWSUtils.getZeroInteger(kv2.getValue()));
//			KeyValueBean kv3 = tmpRaitenYoinList.get(2);
//			stmt.setString(14, kv3.getKey());
//			stmt.setInt(15, BSWSUtils.getZeroInteger(kv3.getValue()));
//			KeyValueBean kv4 = tmpRaitenYoinList.get(3);
//			stmt.setString(16, kv4.getKey());
//			stmt.setInt(17, BSWSUtils.getZeroInteger(kv4.getValue()));
//			KeyValueBean kv5 = tmpRaitenYoinList.get(4);
//			stmt.setString(18, kv5.getKey());
//			stmt.setInt(19, BSWSUtils.getZeroInteger(kv5.getValue()));
//			KeyValueBean kv6 = tmpRaitenYoinList.get(5);
//			stmt.setString(20, kv6.getKey());
//			stmt.setInt(21, BSWSUtils.getZeroInteger(kv6.getValue()));
//			KeyValueBean kv7 = tmpRaitenYoinList.get(6);
//			stmt.setString(22, kv7.getKey());
//			stmt.setInt(23, BSWSUtils.getZeroInteger(kv7.getValue()));
//			KeyValueBean kv8 = tmpRaitenYoinList.get(7);
//			stmt.setString(24, kv8.getKey());
//			stmt.setInt(25, BSWSUtils.getZeroInteger(kv8.getValue()));
//		}
//		List<KeyValueBean> tmpUriageShubetsuList = BSWSUtils.getKeyValueBeanList(raitenJohoBean.getUriageShubetsuList(), 8);
//		{
//			KeyValueBean kv1 = tmpUriageShubetsuList.get(0);
//			stmt.setString(26, kv1.getKey());
//			stmt.setInt(27, BSWSUtils.getZeroInteger(kv1.getValue()));
//			KeyValueBean kv2 = tmpUriageShubetsuList.get(1);
//			stmt.setString(28, kv2.getKey());
//			stmt.setInt(29, BSWSUtils.getZeroInteger(kv2.getValue()));
//			KeyValueBean kv3 = tmpUriageShubetsuList.get(2);
//			stmt.setString(30, kv3.getKey());
//			stmt.setInt(31, BSWSUtils.getZeroInteger(kv3.getValue()));
//			KeyValueBean kv4 = tmpUriageShubetsuList.get(3);
//			stmt.setString(32, kv4.getKey());
//			stmt.setInt(33, BSWSUtils.getZeroInteger(kv4.getValue()));
//			KeyValueBean kv5 = tmpUriageShubetsuList.get(4);
//			stmt.setString(34, kv5.getKey());
//			stmt.setInt(35, BSWSUtils.getZeroInteger(kv5.getValue()));
//			KeyValueBean kv6 = tmpUriageShubetsuList.get(5);
//			stmt.setString(36, kv6.getKey());
//			stmt.setInt(37, BSWSUtils.getZeroInteger(kv6.getValue()));
//			KeyValueBean kv7 = tmpUriageShubetsuList.get(6);
//			stmt.setString(38, kv7.getKey());
//			stmt.setInt(39, BSWSUtils.getZeroInteger(kv7.getValue()));
//			KeyValueBean kv8 = tmpUriageShubetsuList.get(7);
//			stmt.setString(40, kv8.getKey());
//			stmt.setInt(41, BSWSUtils.getZeroInteger(kv8.getValue()));
//		}
//		List<KeyValueBean> tmpShiharaiHohoList = BSWSUtils.getKeyValueBeanList(raitenJohoBean.getShiharaiHohoList(), 5);
//		{
//			KeyValueBean kv1 = tmpShiharaiHohoList.get(0);
//			stmt.setString(42, kv1.getKey());
//			stmt.setInt(43, BSWSUtils.getZeroInteger(kv1.getValue()));
//			KeyValueBean kv2 = tmpShiharaiHohoList.get(1);
//			stmt.setString(44, kv2.getKey());
//			stmt.setInt(45, BSWSUtils.getZeroInteger(kv2.getValue()));
//			KeyValueBean kv3 = tmpShiharaiHohoList.get(2);
//			stmt.setString(46, kv3.getKey());
//			stmt.setInt(47, BSWSUtils.getZeroInteger(kv3.getValue()));
//			KeyValueBean kv4 = tmpShiharaiHohoList.get(3);
//			stmt.setString(48, kv4.getKey());
//			stmt.setInt(49, BSWSUtils.getZeroInteger(kv4.getValue()));
//			KeyValueBean kv5 = tmpShiharaiHohoList.get(4);
//			stmt.setString(50, kv5.getKey());
//			stmt.setInt(51, BSWSUtils.getZeroInteger(kv5.getValue()));
//		}
//		List<KeyValueBean> tmpHosyuShubetsuList = BSWSUtils.getKeyValueBeanList(raitenJohoBean.getHosyuShubetsuList(), 8);
//		{
//			KeyValueBean kv1 = tmpHosyuShubetsuList.get(0);
//			stmt.setString(52, kv1.getKey());
//			stmt.setInt(53, BSWSUtils.getZeroInteger(kv1.getValue()));
//			KeyValueBean kv2 = tmpHosyuShubetsuList.get(1);
//			stmt.setString(54, kv2.getKey());
//			stmt.setInt(55, BSWSUtils.getZeroInteger(kv2.getValue()));
//			KeyValueBean kv3 = tmpHosyuShubetsuList.get(2);
//			stmt.setString(56, kv3.getKey());
//			stmt.setInt(57, BSWSUtils.getZeroInteger(kv3.getValue()));
//			KeyValueBean kv4 = tmpHosyuShubetsuList.get(3);
//			stmt.setString(58, kv4.getKey());
//			stmt.setInt(59, BSWSUtils.getZeroInteger(kv4.getValue()));
//			KeyValueBean kv5 = tmpHosyuShubetsuList.get(4);
//			stmt.setString(60, kv5.getKey());
//			stmt.setInt(61, BSWSUtils.getZeroInteger(kv5.getValue()));
//			KeyValueBean kv6 = tmpHosyuShubetsuList.get(5);
//			stmt.setString(62, kv6.getKey());
//			stmt.setInt(63, BSWSUtils.getZeroInteger(kv6.getValue()));
//			KeyValueBean kv7 = tmpHosyuShubetsuList.get(6);
//			stmt.setString(64, kv7.getKey());
//			stmt.setInt(65, BSWSUtils.getZeroInteger(kv7.getValue()));
//			KeyValueBean kv8 = tmpHosyuShubetsuList.get(7);
//			stmt.setString(66, kv8.getKey());
//			stmt.setInt(67, BSWSUtils.getZeroInteger(kv8.getValue()));
//		}
//		stmt.setString(68, bSWSSession.getStrJugyoinCod());
//		stmt.setString(69, bSWSSession.getStrGroupCod());
//		stmt.setString(70, strSansyoTenpoCod);
//		stmt.setInt(71, Integer.parseInt(strSansyoYmd));
//		stmt.setString(72, raitenJohoBean.getStrTantoCod());
//
//		int cnt = stmt.executeUpdate();
//
//		stmt.close();
//
//		return cnt;
//	}
//
//	private final String SQL_CNT_URIAGE_SYOSAI =
//		" SELECT " +
//		"     COUNT(*) CNT " +
//		" FROM " +
//		"     T_URIAGE_SYOSAI " +
//		" WHERE " +
//		"     TENPO_COD = ? " +
//		" AND URIAGE_YMD = ? "+
//		" AND JUGYOIN_COD = ? ";
//
//	/**
//     * 売上情報の存在確認
//     * 引数のPKがあれば条件とする。
//     */
//	public int getDayUriageJohoCnt(Connection con, String pkGroupCod, String pkTenpoCod, String strUriageYmd, String strJugyoinCod) throws Exception{
//
//		int resCnt = 0;
//		PreparedStatement stmt = con.prepareStatement(SQL_CNT_URIAGE_SYOSAI);
//		stmt.setString(1, pkTenpoCod);
//		stmt.setInt(2, Integer.parseInt(strUriageYmd));
//		stmt.setString(3, strJugyoinCod);
//
//		ResultSet rs = stmt.executeQuery();
//
//		while(rs.next()){
//			resCnt = rs.getInt("CNT");
//		}
//		rs.close();
//		stmt.close();
//
//		return resCnt;
//	}
//
//	/**
//     * 売上情報取得
//     * 引数のPKがあれば条件とする。
//     */
//	public ArrayList<UriageModel> getDayUriageJoho(Connection con, String pkGroupCod, String pkTenpoCod, int intUriageYmd) throws Exception{
//
//		ArrayList<UriageSyosaiModel> resultList = new ArrayList<UriageSyosaiModel>();
//
//		PreparedStatement stmt = con.prepareStatement(SQL_RAITENJOHO);
//		stmt.setString(1, pkTenpoCod);
//		stmt.setInt(2, intUriageYmd);
//		stmt.setString(3, pkGroupCod);
//		stmt.setString(4, pkTenpoCod);
//		stmt.setInt(5, intUriageYmd);
//		ResultSet rs = stmt.executeQuery();
//
//		UriageSyosaiModel uriageSyosaiModel = null;
//		while(rs.next()){
//			uriageSyosaiModel = new UriageSyosaiModel();
//			String strTenpoCod = rs.getString("TENPO_COD");
//			String strJugyoinCod = rs.getString("JUGYOIN_COD");
//			String strJugyoinKnj = rs.getString("JUGYOIN_KNJ");
//			String strGenkinShutsuno1Cod = rs.getString("GENKIN_SHUTSUNO1_COD");
//			Integer intGenkinShutsuno1Kin = rs.getInt("GENKIN_SHUTSUNO1_KIN");
//			String strGenkinShutsuno2Cod = rs.getString("GENKIN_SHUTSUNO2_COD");
//			Integer intGenkinShutsuno2Kin = rs.getInt("GENKIN_SHUTSUNO2_KIN");
//			String strGenkinShutsuno3Cod = rs.getString("GENKIN_SHUTSUNO3_COD");
//			Integer intGenkinShutsuno3Kin = rs.getInt("GENKIN_SHUTSUNO3_KIN");
//			String strGenkinShutsuno4Cod = rs.getString("GENKIN_SHUTSUNO4_COD");
//			Integer intGenkinShutsuno4Kin = rs.getInt("GENKIN_SHUTSUNO4_KIN");
//			String strGenkinShutsuno5Cod = rs.getString("GENKIN_SHUTSUNO5_COD");
//			Integer intGenkinShutsuno5Kin = rs.getInt("GENKIN_SHUTSUNO5_KIN");
//			String strGenkinShutsuno6Cod = rs.getString("GENKIN_SHUTSUNO6_COD");
//			Integer intGenkinShutsuno6Kin = rs.getInt("GENKIN_SHUTSUNO6_KIN");
//			String strGenkinShutsuno7Cod = rs.getString("GENKIN_SHUTSUNO7_COD");
//			Integer intGenkinShutsuno7Kin = rs.getInt("GENKIN_SHUTSUNO7_KIN");
//			String strGenkinShutsuno8Cod = rs.getString("GENKIN_SHUTSUNO8_COD");
//			Integer intGenkinShutsuno8Kin = rs.getInt("GENKIN_SHUTSUNO8_KIN");
//			String strGenkinShutsuno9Cod = rs.getString("GENKIN_SHUTSUNO9_COD");
//			Integer intGenkinShutsuno9Kin = rs.getInt("GENKIN_SHUTSUNO9_KIN");
//			String strGenkinShutsuno10Cod = rs.getString("GENKIN_SHUTSUNO10_COD");
//			Integer intGenkinShutsuno10Kin = rs.getInt("GENKIN_SHUTSUNO10_KIN");
//			Integer intShinkiSu = rs.getInt("SHINKI_SU");
//			Integer intSairaiSu = rs.getInt("SAIRAI_SU");
//			Integer intShimeiSu = rs.getInt("SHIMEI_SU");
//			Integer intNyukyakuSu = rs.getInt("NYUKYAKU_SU");
//			Integer intHontaiKin = rs.getInt("HONTAI_KIN");
//			Integer intSyohizeiKbn = rs.getInt("SYOHIZEI_KIN");
//			Integer intUriageGokeiKin = rs.getInt("URIAGE_GOKEI_KIN");
//			Integer intTankaKin = rs.getInt("TANKA_KIN");
//			Integer intHosyuGokeiKin = rs.getInt("HOSYU_GOKEI_KIN");
//			String strRaitenYoin1Cod = rs.getString("RAITEN_YOIN1_COD");
//			Integer intRaitenYoin1Su = rs.getInt("RAITEN_YOIN1_SU");
//			String strRaitenYoin2Cod = rs.getString("RAITEN_YOIN2_COD");
//			Integer intRaitenYoin2Su = rs.getInt("RAITEN_YOIN2_SU");
//			String strRaitenYoin3Cod = rs.getString("RAITEN_YOIN3_COD");
//			Integer intRaitenYoin3Su = rs.getInt("RAITEN_YOIN3_SU");
//			String strRaitenYoin4Cod = rs.getString("RAITEN_YOIN4_COD");
//			Integer intRaitenYoin4Su = rs.getInt("RAITEN_YOIN4_SU");
//			String strRaitenYoin5Cod = rs.getString("RAITEN_YOIN5_COD");
//			Integer intRaitenYoin5Su = rs.getInt("RAITEN_YOIN5_SU");
//			String strRaitenYoin6Cod = rs.getString("RAITEN_YOIN6_COD");
//			Integer intRaitenYoin6Su = rs.getInt("RAITEN_YOIN6_SU");
//			String strRaitenYoin7Cod = rs.getString("RAITEN_YOIN7_COD");
//			Integer intRaitenYoin7Su = rs.getInt("RAITEN_YOIN7_SU");
//			String strRaitenYoin8Cod = rs.getString("RAITEN_YOIN8_COD");
//			Integer intRaitenYoin8Su = rs.getInt("RAITEN_YOIN8_SU");
//			String strUriageShubetsu1Cod = rs.getString("URIAGE_SHUBETSU1_COD");
//			Integer intUriageShubetsu1Kin = rs.getInt("URIAGE_SHUBETSU1_KIN");
//			String strUriageShubetsu2Cod = rs.getString("URIAGE_SHUBETSU2_COD");
//			Integer intUriageShubetsu2Kin = rs.getInt("URIAGE_SHUBETSU2_KIN");
//			String strUriageShubetsu3Cod = rs.getString("URIAGE_SHUBETSU3_COD");
//			Integer intUriageShubetsu3Kin = rs.getInt("URIAGE_SHUBETSU3_KIN");
//			String strUriageShubetsu4Cod = rs.getString("URIAGE_SHUBETSU4_COD");
//			Integer intUriageShubetsu4Kin = rs.getInt("URIAGE_SHUBETSU4_KIN");
//			String strUriageShubetsu5Cod = rs.getString("URIAGE_SHUBETSU5_COD");
//			Integer intUriageShubetsu5Kin = rs.getInt("URIAGE_SHUBETSU5_KIN");
//			String strUriageShubetsu6Cod = rs.getString("URIAGE_SHUBETSU6_COD");
//			Integer intUriageShubetsu6Kin = rs.getInt("URIAGE_SHUBETSU6_KIN");
//			String strUriageShubetsu7Cod = rs.getString("URIAGE_SHUBETSU7_COD");
//			Integer intUriageShubetsu7Kin = rs.getInt("URIAGE_SHUBETSU7_KIN");
//			String strUriageShubetsu8Cod = rs.getString("URIAGE_SHUBETSU8_COD");
//			Integer intUriageShubetsu8Kin = rs.getInt("URIAGE_SHUBETSU8_KIN");
//			String strShiharaiHoho1Cod = rs.getString("SHIHARAI_HOHO1_COD");
//			Integer intShiharaiHoho1Kin = rs.getInt("SHIHARAI_HOHO1_KIN");
//			String strShiharaiHoho2Cod = rs.getString("SHIHARAI_HOHO2_COD");
//			Integer intShiharaiHoho2Kin = rs.getInt("SHIHARAI_HOHO2_KIN");
//			String strShiharaiHoho3Cod = rs.getString("SHIHARAI_HOHO3_COD");
//			Integer intShiharaiHoho3Kin = rs.getInt("SHIHARAI_HOHO3_KIN");
//			String strShiharaiHoho4Cod = rs.getString("SHIHARAI_HOHO4_COD");
//			Integer intShiharaiHoho4Kin = rs.getInt("SHIHARAI_HOHO4_KIN");
//			String strShiharaiHoho5Cod = rs.getString("SHIHARAI_HOHO5_COD");
//			Integer intShiharaiHoho5Kin = rs.getInt("SHIHARAI_HOHO5_KIN");
//			String strHosyuShubetsu1Cod = rs.getString("HOSYU_SHUBETSU1_COD");
//			Integer intHosyuShubetsu1Kin = rs.getInt("HOSYU_SHUBETSU1_KIN");
//			String strHosyuShubetsu2Cod = rs.getString("HOSYU_SHUBETSU2_COD");
//			Integer intHosyuShubetsu2Kin = rs.getInt("HOSYU_SHUBETSU2_KIN");
//			String strHosyuShubetsu3Cod = rs.getString("HOSYU_SHUBETSU3_COD");
//			Integer intHosyuShubetsu3Kin = rs.getInt("HOSYU_SHUBETSU3_KIN");
//			String strHosyuShubetsu4Cod = rs.getString("HOSYU_SHUBETSU4_COD");
//			Integer intHosyuShubetsu4Kin = rs.getInt("HOSYU_SHUBETSU4_KIN");
//			String strHosyuShubetsu5Cod = rs.getString("HOSYU_SHUBETSU5_COD");
//			Integer intHosyuShubetsu5Kin = rs.getInt("HOSYU_SHUBETSU5_KIN");
//			String strHosyuShubetsu6Cod = rs.getString("HOSYU_SHUBETSU6_COD");
//			Integer intHosyuShubetsu6Kin = rs.getInt("HOSYU_SHUBETSU6_KIN");
//			String strHosyuShubetsu7Cod = rs.getString("HOSYU_SHUBETSU7_COD");
//			Integer intHosyuShubetsu7Kin = rs.getInt("HOSYU_SHUBETSU7_KIN");
//			String strHosyuShubetsu8Cod = rs.getString("HOSYU_SHUBETSU8_COD");
//			Integer intHosyuShubetsu8Kin = rs.getInt("HOSYU_SHUBETSU8_KIN");
//
//			uriageSyosaiModel.setStrTenpoCod(strTenpoCod);
//			uriageSyosaiModel.setStrJugyoinCod(strJugyoinCod);
//			uriageSyosaiModel.setStrJugyoinKnj(strJugyoinKnj);
//			uriageSyosaiModel.setStrGenkinShutsuno1Cod(strGenkinShutsuno1Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno1Kin(intGenkinShutsuno1Kin);
//			uriageSyosaiModel.setStrGenkinShutsuno2Cod(strGenkinShutsuno2Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno2Kin(intGenkinShutsuno2Kin);
//			uriageSyosaiModel.setStrGenkinShutsuno3Cod(strGenkinShutsuno3Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno3Kin(intGenkinShutsuno3Kin);
//			uriageSyosaiModel.setStrGenkinShutsuno4Cod(strGenkinShutsuno4Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno4Kin(intGenkinShutsuno4Kin);
//			uriageSyosaiModel.setStrGenkinShutsuno5Cod(strGenkinShutsuno5Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno5Kin(intGenkinShutsuno5Kin);
//			uriageSyosaiModel.setStrGenkinShutsuno6Cod(strGenkinShutsuno6Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno6Kin(intGenkinShutsuno6Kin);
//			uriageSyosaiModel.setStrGenkinShutsuno7Cod(strGenkinShutsuno7Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno7Kin(intGenkinShutsuno7Kin);
//			uriageSyosaiModel.setStrGenkinShutsuno8Cod(strGenkinShutsuno8Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno8Kin(intGenkinShutsuno8Kin);
//			uriageSyosaiModel.setStrGenkinShutsuno9Cod(strGenkinShutsuno9Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno9Kin(intGenkinShutsuno9Kin);
//			uriageSyosaiModel.setStrGenkinShutsuno10Cod(strGenkinShutsuno10Cod);
//			uriageSyosaiModel.setIntGenkinShutsuno10Kin(intGenkinShutsuno10Kin);
//			uriageSyosaiModel.setIntShinkiSu(intShinkiSu);
//			uriageSyosaiModel.setIntSairaiSu(intSairaiSu);
//			uriageSyosaiModel.setIntShimeiSu(intShimeiSu);
//			uriageSyosaiModel.setIntNyukyakuSu(intNyukyakuSu);
//			uriageSyosaiModel.setIntHontaiKin(intHontaiKin);
//			uriageSyosaiModel.setIntSyohizeiKin(intSyohizeiKbn);
//			uriageSyosaiModel.setIntUriageGokeiKin(intUriageGokeiKin);
//			uriageSyosaiModel.setIntTankaKin(intTankaKin);
//			uriageSyosaiModel.setIntHosyuGokeiKin(intHosyuGokeiKin);
//			uriageSyosaiModel.setStrRaitenYoin1Cod(strRaitenYoin1Cod);
//			uriageSyosaiModel.setIntRaitenYoin1Su(intRaitenYoin1Su);
//			uriageSyosaiModel.setStrRaitenYoin2Cod(strRaitenYoin2Cod);
//			uriageSyosaiModel.setIntRaitenYoin2Su(intRaitenYoin2Su);
//			uriageSyosaiModel.setStrRaitenYoin3Cod(strRaitenYoin3Cod);
//			uriageSyosaiModel.setIntRaitenYoin3Su(intRaitenYoin3Su);
//			uriageSyosaiModel.setStrRaitenYoin4Cod(strRaitenYoin4Cod);
//			uriageSyosaiModel.setIntRaitenYoin4Su(intRaitenYoin4Su);
//			uriageSyosaiModel.setStrRaitenYoin5Cod(strRaitenYoin5Cod);
//			uriageSyosaiModel.setIntRaitenYoin5Su(intRaitenYoin5Su);
//			uriageSyosaiModel.setStrRaitenYoin6Cod(strRaitenYoin6Cod);
//			uriageSyosaiModel.setIntRaitenYoin6Su(intRaitenYoin6Su);
//			uriageSyosaiModel.setStrRaitenYoin7Cod(strRaitenYoin7Cod);
//			uriageSyosaiModel.setIntRaitenYoin7Su(intRaitenYoin7Su);
//			uriageSyosaiModel.setStrRaitenYoin8Cod(strRaitenYoin8Cod);
//			uriageSyosaiModel.setIntRaitenYoin8Su(intRaitenYoin8Su);
//			uriageSyosaiModel.setStrUriageShubetsu1Cod(strUriageShubetsu1Cod);
//			uriageSyosaiModel.setIntUriageShubetsu1Kin(intUriageShubetsu1Kin);
//			uriageSyosaiModel.setStrUriageShubetsu2Cod(strUriageShubetsu2Cod);
//			uriageSyosaiModel.setIntUriageShubetsu2Kin(intUriageShubetsu2Kin);
//			uriageSyosaiModel.setStrUriageShubetsu3Cod(strUriageShubetsu3Cod);
//			uriageSyosaiModel.setIntUriageShubetsu3Kin(intUriageShubetsu3Kin);
//			uriageSyosaiModel.setStrUriageShubetsu4Cod(strUriageShubetsu4Cod);
//			uriageSyosaiModel.setIntUriageShubetsu4Kin(intUriageShubetsu4Kin);
//			uriageSyosaiModel.setStrUriageShubetsu5Cod(strUriageShubetsu5Cod);
//			uriageSyosaiModel.setIntUriageShubetsu5Kin(intUriageShubetsu5Kin);
//			uriageSyosaiModel.setStrUriageShubetsu6Cod(strUriageShubetsu6Cod);
//			uriageSyosaiModel.setIntUriageShubetsu6Kin(intUriageShubetsu6Kin);
//			uriageSyosaiModel.setStrUriageShubetsu7Cod(strUriageShubetsu7Cod);
//			uriageSyosaiModel.setIntUriageShubetsu7Kin(intUriageShubetsu7Kin);
//			uriageSyosaiModel.setStrUriageShubetsu8Cod(strUriageShubetsu8Cod);
//			uriageSyosaiModel.setIntUriageShubetsu8Kin(intUriageShubetsu8Kin);
//			uriageSyosaiModel.setStrShiharaiHoho1Cod(strShiharaiHoho1Cod);
//			uriageSyosaiModel.setIntShiharaiHoho1Kin(intShiharaiHoho1Kin);
//			uriageSyosaiModel.setStrShiharaiHoho2Cod(strShiharaiHoho2Cod);
//			uriageSyosaiModel.setIntShiharaiHoho2Kin(intShiharaiHoho2Kin);
//			uriageSyosaiModel.setStrShiharaiHoho3Cod(strShiharaiHoho3Cod);
//			uriageSyosaiModel.setIntShiharaiHoho3Kin(intShiharaiHoho3Kin);
//			uriageSyosaiModel.setStrShiharaiHoho4Cod(strShiharaiHoho4Cod);
//			uriageSyosaiModel.setIntShiharaiHoho4Kin(intShiharaiHoho4Kin);
//			uriageSyosaiModel.setStrShiharaiHoho5Cod(strShiharaiHoho5Cod);
//			uriageSyosaiModel.setIntShiharaiHoho5Kin(intShiharaiHoho5Kin);
//			uriageSyosaiModel.setStrHosyuShubetsu1Cod(strHosyuShubetsu1Cod);
//			uriageSyosaiModel.setIntHosyuShubetsu1Kin(intHosyuShubetsu1Kin);
//			uriageSyosaiModel.setStrHosyuShubetsu2Cod(strHosyuShubetsu2Cod);
//			uriageSyosaiModel.setIntHosyuShubetsu2Kin(intHosyuShubetsu2Kin);
//			uriageSyosaiModel.setStrHosyuShubetsu3Cod(strHosyuShubetsu3Cod);
//			uriageSyosaiModel.setIntHosyuShubetsu3Kin(intHosyuShubetsu3Kin);
//			uriageSyosaiModel.setStrHosyuShubetsu4Cod(strHosyuShubetsu4Cod);
//			uriageSyosaiModel.setIntHosyuShubetsu4Kin(intHosyuShubetsu4Kin);
//			uriageSyosaiModel.setStrHosyuShubetsu5Cod(strHosyuShubetsu5Cod);
//			uriageSyosaiModel.setIntHosyuShubetsu5Kin(intHosyuShubetsu5Kin);
//			uriageSyosaiModel.setStrHosyuShubetsu6Cod(strHosyuShubetsu6Cod);
//			uriageSyosaiModel.setIntHosyuShubetsu6Kin(intHosyuShubetsu6Kin);
//			uriageSyosaiModel.setStrHosyuShubetsu7Cod(strHosyuShubetsu7Cod);
//			uriageSyosaiModel.setIntHosyuShubetsu7Kin(intHosyuShubetsu7Kin);
//			uriageSyosaiModel.setStrHosyuShubetsu8Cod(strHosyuShubetsu8Cod);
//			uriageSyosaiModel.setIntHosyuShubetsu8Kin(intHosyuShubetsu8Kin);
//
//			resultList.add(uriageSyosaiModel);
//		}
//
//		rs.close();
//		stmt.close();
//
//		return resultList;
//	}
//
//	private final String SQL_RAITENJOHO =
//		" SELECT " +
//		"      J.TENPO_COD " +
//		"     ,J.JUGYOIN_COD " +
//		"     ,J.JUGYOIN_KNJ " +
//		"     ,U.URIAGE_YMD " +
//		"     ,U.GENKIN_SHUTSUNO1_COD " +
//		"     ,U.GENKIN_SHUTSUNO1_KIN " +
//		"     ,U.GENKIN_SHUTSUNO2_COD " +
//		"     ,U.GENKIN_SHUTSUNO2_KIN " +
//		"     ,U.GENKIN_SHUTSUNO3_COD " +
//		"     ,U.GENKIN_SHUTSUNO3_KIN " +
//		"     ,U.GENKIN_SHUTSUNO4_COD " +
//		"     ,U.GENKIN_SHUTSUNO4_KIN " +
//		"     ,U.GENKIN_SHUTSUNO5_COD " +
//		"     ,U.GENKIN_SHUTSUNO5_KIN " +
//		"     ,U.GENKIN_SHUTSUNO6_COD " +
//		"     ,U.GENKIN_SHUTSUNO6_KIN " +
//		"     ,U.GENKIN_SHUTSUNO7_COD " +
//		"     ,U.GENKIN_SHUTSUNO7_KIN " +
//		"     ,U.GENKIN_SHUTSUNO8_COD " +
//		"     ,U.GENKIN_SHUTSUNO8_KIN " +
//		"     ,U.GENKIN_SHUTSUNO9_COD " +
//		"     ,U.GENKIN_SHUTSUNO9_KIN " +
//		"     ,U.GENKIN_SHUTSUNO10_COD " +
//		"     ,U.GENKIN_SHUTSUNO10_KIN " +
//		"     ,U.SHINKI_SU " +
//		"     ,U.SAIRAI_SU " +
//		"     ,U.SHIMEI_SU " +
//		"     ,U.NYUKYAKU_SU " +
//		"     ,U.HONTAI_KIN " +
//		"     ,U.SYOHIZEI_KIN " +
//		"     ,U.URIAGE_GOKEI_KIN " +
//		"     ,U.TANKA_KIN " +
//		"     ,U.HOSYU_GOKEI_KIN " +
//		"     ,U.RAITEN_YOIN1_COD " +
//		"     ,U.RAITEN_YOIN1_SU " +
//		"     ,U.RAITEN_YOIN2_COD " +
//		"     ,U.RAITEN_YOIN2_SU " +
//		"     ,U.RAITEN_YOIN3_COD " +
//		"     ,U.RAITEN_YOIN3_SU " +
//		"     ,U.RAITEN_YOIN4_COD " +
//		"     ,U.RAITEN_YOIN4_SU " +
//		"     ,U.RAITEN_YOIN5_COD " +
//		"     ,U.RAITEN_YOIN5_SU " +
//		"     ,U.RAITEN_YOIN6_COD " +
//		"     ,U.RAITEN_YOIN6_SU " +
//		"     ,U.RAITEN_YOIN7_COD " +
//		"     ,U.RAITEN_YOIN7_SU " +
//		"     ,U.RAITEN_YOIN8_COD " +
//		"     ,U.RAITEN_YOIN8_SU " +
//		"     ,U.URIAGE_SHUBETSU1_COD " +
//		"     ,U.URIAGE_SHUBETSU1_KIN " +
//		"     ,U.URIAGE_SHUBETSU2_COD " +
//		"     ,U.URIAGE_SHUBETSU2_KIN " +
//		"     ,U.URIAGE_SHUBETSU3_COD " +
//		"     ,U.URIAGE_SHUBETSU3_KIN " +
//		"     ,U.URIAGE_SHUBETSU4_COD " +
//		"     ,U.URIAGE_SHUBETSU4_KIN " +
//		"     ,U.URIAGE_SHUBETSU5_COD " +
//		"     ,U.URIAGE_SHUBETSU5_KIN " +
//		"     ,U.URIAGE_SHUBETSU6_COD " +
//		"     ,U.URIAGE_SHUBETSU6_KIN " +
//		"     ,U.URIAGE_SHUBETSU7_COD " +
//		"     ,U.URIAGE_SHUBETSU7_KIN " +
//		"     ,U.URIAGE_SHUBETSU8_COD " +
//		"     ,U.URIAGE_SHUBETSU8_KIN " +
//		"     ,U.SHIHARAI_HOHO1_COD " +
//		"     ,U.SHIHARAI_HOHO1_KIN " +
//		"     ,U.SHIHARAI_HOHO2_COD " +
//		"     ,U.SHIHARAI_HOHO2_KIN " +
//		"     ,U.SHIHARAI_HOHO3_COD " +
//		"     ,U.SHIHARAI_HOHO3_KIN " +
//		"     ,U.SHIHARAI_HOHO4_COD " +
//		"     ,U.SHIHARAI_HOHO4_KIN " +
//		"     ,U.SHIHARAI_HOHO5_COD " +
//		"     ,U.SHIHARAI_HOHO5_KIN " +
//		"     ,U.HOSYU_SHUBETSU1_COD " +
//		"     ,U.HOSYU_SHUBETSU1_KIN " +
//		"     ,U.HOSYU_SHUBETSU2_COD " +
//		"     ,U.HOSYU_SHUBETSU2_KIN " +
//		"     ,U.HOSYU_SHUBETSU3_COD " +
//		"     ,U.HOSYU_SHUBETSU3_KIN " +
//		"     ,U.HOSYU_SHUBETSU4_COD " +
//		"     ,U.HOSYU_SHUBETSU4_KIN " +
//		"     ,U.HOSYU_SHUBETSU5_COD " +
//		"     ,U.HOSYU_SHUBETSU5_KIN " +
//		"     ,U.HOSYU_SHUBETSU6_COD " +
//		"     ,U.HOSYU_SHUBETSU6_KIN " +
//		"     ,U.HOSYU_SHUBETSU7_COD " +
//		"     ,U.HOSYU_SHUBETSU7_KIN " +
//		"     ,U.HOSYU_SHUBETSU8_COD " +
//		"     ,U.HOSYU_SHUBETSU8_KIN " +
//		" FROM " +
//		"     M_JUGYOIN J " +
//		"     LEFT OUTER JOIN " +
//		"         ( SELECT " +
//		"               H.TENPO_COD " +
//		"              ,H.URIAGE_YMD " +
//		"              ,H.GENKIN_SHUTSUNO1_COD " +
//		"              ,H.GENKIN_SHUTSUNO1_KIN " +
//		"              ,H.GENKIN_SHUTSUNO2_COD " +
//		"              ,H.GENKIN_SHUTSUNO2_KIN " +
//		"              ,H.GENKIN_SHUTSUNO3_COD " +
//		"              ,H.GENKIN_SHUTSUNO3_KIN " +
//		"              ,H.GENKIN_SHUTSUNO4_COD " +
//		"              ,H.GENKIN_SHUTSUNO4_KIN " +
//		"              ,H.GENKIN_SHUTSUNO5_COD " +
//		"              ,H.GENKIN_SHUTSUNO5_KIN " +
//		"              ,H.GENKIN_SHUTSUNO6_COD " +
//		"              ,H.GENKIN_SHUTSUNO6_KIN " +
//		"              ,H.GENKIN_SHUTSUNO7_COD " +
//		"              ,H.GENKIN_SHUTSUNO7_KIN " +
//		"              ,H.GENKIN_SHUTSUNO8_COD " +
//		"              ,H.GENKIN_SHUTSUNO8_KIN " +
//		"              ,H.GENKIN_SHUTSUNO9_COD " +
//		"              ,H.GENKIN_SHUTSUNO9_KIN " +
//		"              ,H.GENKIN_SHUTSUNO10_COD " +
//		"              ,H.GENKIN_SHUTSUNO10_KIN " +
//		"              ,S.JUGYOIN_COD " +
//		"              ,S.SHINKI_SU " +
//		"              ,S.SAIRAI_SU " +
//		"              ,S.SHIMEI_SU " +
//		"              ,S.NYUKYAKU_SU " +
//		"              ,S.HONTAI_KIN " +
//		"              ,S.SYOHIZEI_KIN " +
//		"              ,S.URIAGE_GOKEI_KIN " +
//		"              ,S.TANKA_KIN " +
//		"              ,S.HOSYU_GOKEI_KIN " +
//		"              ,S.RAITEN_YOIN1_COD " +
//		"              ,S.RAITEN_YOIN1_SU " +
//		"              ,S.RAITEN_YOIN2_COD " +
//		"              ,S.RAITEN_YOIN2_SU " +
//		"              ,S.RAITEN_YOIN3_COD " +
//		"              ,S.RAITEN_YOIN3_SU " +
//		"              ,S.RAITEN_YOIN4_COD " +
//		"              ,S.RAITEN_YOIN4_SU " +
//		"              ,S.RAITEN_YOIN5_COD " +
//		"              ,S.RAITEN_YOIN5_SU " +
//		"              ,S.RAITEN_YOIN6_COD " +
//		"              ,S.RAITEN_YOIN6_SU " +
//		"              ,S.RAITEN_YOIN7_COD " +
//		"              ,S.RAITEN_YOIN7_SU " +
//		"              ,S.RAITEN_YOIN8_COD " +
//		"              ,S.RAITEN_YOIN8_SU " +
//		"              ,S.URIAGE_SHUBETSU1_COD " +
//		"              ,S.URIAGE_SHUBETSU1_KIN " +
//		"              ,S.URIAGE_SHUBETSU2_COD " +
//		"              ,S.URIAGE_SHUBETSU2_KIN " +
//		"              ,S.URIAGE_SHUBETSU3_COD " +
//		"              ,S.URIAGE_SHUBETSU3_KIN " +
//		"              ,S.URIAGE_SHUBETSU4_COD " +
//		"              ,S.URIAGE_SHUBETSU4_KIN " +
//		"              ,S.URIAGE_SHUBETSU5_COD " +
//		"              ,S.URIAGE_SHUBETSU5_KIN " +
//		"              ,S.URIAGE_SHUBETSU6_COD " +
//		"              ,S.URIAGE_SHUBETSU6_KIN " +
//		"              ,S.URIAGE_SHUBETSU7_COD " +
//		"              ,S.URIAGE_SHUBETSU7_KIN " +
//		"              ,S.URIAGE_SHUBETSU8_COD " +
//		"              ,S.URIAGE_SHUBETSU8_KIN " +
//		"              ,S.SHIHARAI_HOHO1_COD " +
//		"              ,S.SHIHARAI_HOHO1_KIN " +
//		"              ,S.SHIHARAI_HOHO2_COD " +
//		"              ,S.SHIHARAI_HOHO2_KIN " +
//		"              ,S.SHIHARAI_HOHO3_COD " +
//		"              ,S.SHIHARAI_HOHO3_KIN " +
//		"              ,S.SHIHARAI_HOHO4_COD " +
//		"              ,S.SHIHARAI_HOHO4_KIN " +
//		"              ,S.SHIHARAI_HOHO5_COD " +
//		"              ,S.SHIHARAI_HOHO5_KIN " +
//		"              ,S.HOSYU_SHUBETSU1_COD " +
//		"              ,S.HOSYU_SHUBETSU1_KIN " +
//		"              ,S.HOSYU_SHUBETSU2_COD " +
//		"              ,S.HOSYU_SHUBETSU2_KIN " +
//		"              ,S.HOSYU_SHUBETSU3_COD " +
//		"              ,S.HOSYU_SHUBETSU3_KIN " +
//		"              ,S.HOSYU_SHUBETSU4_COD " +
//		"              ,S.HOSYU_SHUBETSU4_KIN " +
//		"              ,S.HOSYU_SHUBETSU5_COD " +
//		"              ,S.HOSYU_SHUBETSU5_KIN " +
//		"              ,S.HOSYU_SHUBETSU6_COD " +
//		"              ,S.HOSYU_SHUBETSU6_KIN " +
//		"              ,S.HOSYU_SHUBETSU7_COD " +
//		"              ,S.HOSYU_SHUBETSU7_KIN " +
//		"              ,S.HOSYU_SHUBETSU8_COD " +
//		"              ,S.HOSYU_SHUBETSU8_KIN " +
//		"           FROM " +
//		"               T_URIAGE H " +
//		"              ,T_URIAGE_SYOSAI S " +
//		"           WHERE " +
//		"               H.URIAGE_YMD = S.URIAGE_YMD " +
//		"           AND H.TENPO_COD = S.TENPO_COD " +
//		"           AND H.TENPO_COD = ? " +
//		"           AND H.URIAGE_YMD = ? " +
//		"         ) U ON " +
//		"         ( " +
//		"               J.TENPO_COD = U.TENPO_COD " +
//		"           AND J.JUGYOIN_COD = U.JUGYOIN_COD " +
//		"         ) " +
//		" WHERE J.GROUP_COD = ? " +
//		"     AND J.TENPO_COD = ? " +
//		"     AND ? BETWEEN J.NYUTEN_YMD AND J.TAITEN_YMD ";

}